Tabela LepisodeCaretaker

Definicja tabeli LepisodeCaretaker

Name

LepisodeCaretaker

Code

LepisodeCaretaker

Comment

Opiekun przebywajacy z pacjentem w szpitalu


Lista kolumn tabeli LepisodeCaretaker

Name

Code

lepisodeCaretakerId

lepisodeCaretakerId

episodeId

episodeId

personId

personId

startDt

startDt

stopDt

stopDt

active

active


Kolumna lepisodeCaretakerId tabeli LepisodeCaretaker

Definicja kolumny lepisodeCaretakerId tabeli LepisodeCaretaker

Name

lepisodeCaretakerId

Code

lepisodeCaretakerId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna episodeId tabeli LepisodeCaretaker

Definicja kolumny episodeId tabeli LepisodeCaretaker

Name

episodeId

Code

episodeId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id pobytu


Kolumna personId tabeli LepisodeCaretaker

Definicja kolumny personId tabeli LepisodeCaretaker

Name

personId

Code

personId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id opiekuna pacjenta


Kolumna startDt tabeli LepisodeCaretaker

Definicja kolumny startDt tabeli LepisodeCaretaker

Name

startDt

Code

startDt

Data Type

DATE

Mandatory

No

Comment

data poczatku pobytu
opiekuna z pacjentem


Kolumna stopDt tabeli LepisodeCaretaker

Definicja kolumny stopDt tabeli LepisodeCaretaker

Name

stopDt

Code

stopDt

Data Type

DATE

Mandatory

No

Comment

data konca pobytu opiekuna z
pacjentem


Kolumna active tabeli LepisodeCaretaker

Definicja kolumny active tabeli LepisodeCaretaker

Name

active

Code

active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Lista kluczy tabeli LepisodeCaretaker

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LepisodeCaretaker

Definicja klucza Identifier_1 tabeli LepisodeCaretaker

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment